# -*- coding: utf-8 -*-
"""
Created on Sat Aug 15 11:15:45 2020

@author: Lenovo
"""
import pandas as pd
from openpyxl import load_workbook

writer = pd.ExcelWriter('3.xlsx',engine='openpyxl') #要创建的新表
book=load_workbook('2.xlsx') #将原表的数据保存
writer.book=book
df=pd.read_excel('2.xlsx',sheet_name=-1)
for i in range(17,32):
    name = '8月'+str(i)+'日'
    df['日期']='2020/8/'+str(i)
    df.to_excel(writer, sheet_name= name,index=False)
writer.save()
writer.close()